Data Dictionary Assignment Help | Project | Homework Problem Solution

Data directory can said as the basic place where the data files saved or stored and for the data base management we suggest to use data directory assignment help. It can be said a fortunate opportunity of the students to get data directory homework help from our DatabaseHomeworkHelp as we have highest rank in this sector. Windows and other operations systems uses data base and help with data base directory assignment is our main focus to create knowledge about data base management.

Application of data directory is wide and only help with data directory project for the students can get them good marks. Every other scholar looking for data directory problem solution is welcome here. We have the talent to give you data directory online expert tutor in this regard. From windows to Linux and Mac also uses the bitcoins to be saved in data directory which requires data directory assignment help for weak students. Perfection in homework can be brought only by our data directory homework help.

We speak with our market reputation for help with data directory assignment. Complexity of every kind in DBMS is solved via help with data directory project in our company. All kind of data files can be managed with our data directory problem solution and the complex nature of DBMS is now more than easy with our data directory project help.

Data dictionary is a Meta repository and it contains all files in the database. It is a set of tables in read only format and provide information about the database. It contains the definition of all the schema object in the database, information on how space being allocated for schema object, default value on columns and privilege of roles granted to the users.

Note:-  The below sample assignment on Data Dictionary is to showcase our website potential and quality of DBMS assignment help that we provide to all the students across globe. You may also click on other pages to see different solved assignment.

We would also like to make an additional note that the below assignment is not been taken from our previous assignment solution that we had delivered to our students in the past. We never do that and always intended to maintain privacy with our delivery of our homework solution.

Task:

Data dictionary includes the data table structure and the domain. Data dictionary is the meta data which stores the information about the tables and the core entities.

Entities:

The following are the entities given in the case study.

  • Customers
  • Customer Invoices
  • Staff
  • Staff Level
  • Technical Support Calls
  • Access types
  • Plantype
  • Payrate
  • CallStatus

 Data dictionary

Data dictionary includes the data table structure and the domain

Access types
Column Name                  Data Type
accesstype#                      VARCHAR (20)                 notnull PK IDENTITY
maxspeed                           VARCHAR (20)                 Notnull

Plantype
Column Name                                  Data

access type#,                                    VARCHAR (20)                 Notnull
planname#,                                       VARCHAR(20)                  Notnull PK
shapedspeed                                     VARCHAR(50)                  Notnull
offpeak                                                INT                                        Notnull
onpeak                                                 INT                                        Notnull
price VARCHAR(20)                                                                      Notnull Price of the plan (include $)

Customer

Column Name                                  Data Type

CustID                                                  Number                               Not null PK

UserNAME                                         Varchar(15)                      Not Null

planname#                                        VARCHAR(50)                  Not null
firstname                                            VARCHAR(50)                  Not null
lastname                                             VARCHAR(50)                  Not null
address                                                VARCHAR(50)                                                  Not null
DOB                                                      Date

ContactNo                                          Varchar(30)
Invoice
Column Name                                  Data Type
username                                           VARCHAR(15) Not null Fk
invoice#                                              INT Not null PK IDETITY
Date                                                      Date Not null YYYY-MM-DD (default format)
amountowing                                   VARCHAR(20) Not null Amount in dollars

Staff number
Column Name                                  Data Type
staffID                                                  VARCHAR(30) Not null PK IDENTITY
first name                                           VARCHAR (50) Not null
lastname                                             VARCHAR(50) Not null
contactnumber                                VARCHAR(20) Not null
hiredate                                               DATE Not null
mentor#                                             VARCHAR(20) Not null

PayRates

Column Name Data Type & Length Null Constraints Other
staffID, VARCHAR(30) Not null PK IDENTITY
levelname VARCHAR(20) Not Null FK
payrate MONEY Not null

Technical Support Calls

Column Name Data Type & Length Null Constraints Other
username#, VARCHAR(15) Not null fk
StaffID VARCHAR(30) Not null Pk IDENTITY
summary TEXT Not null
misc TEXT Not null
datetime Datetime Not null Date and time can be combined
status VARCHAR(50) Not null
duration TINYINT Not null Time small
HOLDmin TINYINT Not null Time small

dd

Physical database design

dd1

Assumptions:

Callstatus is a separate table to add new status as well. Similarly new pay rates can be added.