cs作业代写_matlab代做_machine learning代写


- 首頁 >> C/C++編程
INFO151 2020-T3
Assignment 4 (30%)

1.An example of a lost item notice from a library to a client is depicted below. You need to organise a database to record this type of information. The lost item notice is issued if the item is still on-loan after 1 year.
Additional information: An item Barcode can determine the item location. There is only one type of related fees, the lost item replacement fee. A client can have multiple lost items in one notice. A client has a unique student ID number which is not shown in the example. In this exercise, there is no requirement to track the current status of any items in the table. There is no need to create a separate ClientID and Client_Name table.

(a)Write the Sqlite command line script to generate the HTML notice like the one shown above including the greeting and the wordings. Submit the script and a screenshot of the resulting notice. [8 marks]

2.An online student record is given below. You are required to develop a database to store the information for generating the record.
Additional Information:
2. A status field records whether a student has completed or not completed the degree.
(a)Total credits points gained, and GPA are computed using aggregate SQL with the weight table without any hardcoding.
(b)The printed date and time are current system time.
(c)For computing GPA, the weights table ( should be included in the database) is given below:

Fail 0
Pass 1
Credit 2
Distinction 3
High Distinction 4

The formula for calculating GPA is to divide the total points earned in a program by the total number of credits attempted. For example Zane Walker GPA = (2*6+3*6+4*6+3*6)/(6+6+6+6) =3.00.
(a)Construct the 1NF dependency diagram, name all the dependencies and indicate the primary key. [12 marks]

(b)Normalise the table into 3rd normal form. You must show the progress from 1NF to 2NF, and then to 3NF. Indicate all the primary keys and foreign keys in all the normalised tables. [8 marks]

(c)Write the DDL to create the normalised tables and indicate the sequence of creating the tables. Provide a screenshot for each table you created. Use appropriate entity names for example Student, Grade, etc. to represent the normalised tables respectively. Use only the affinity data type for the attributes in the tables. [8 marks]

(d)Write the DML in a correct sequence to insert the data of Zane Walker into the respective tables. Provide a screenshot of each table after the insert. Use only the single insert method for each table. [8 marks]

(e)Use the Sqlite command line method to generate a HTML file that will produce the online student record for Zane walker as shown in the diagram. Submit the script and a screenshot of the HTML page. [12 marks]


马来西亚代写,essay代写,留学生网课代修代考,论文代写-小精灵代写 美国Assignment代写,Economic代写,留学作业代写-RMTNR北美代写 美国作业代写,网课代考,cs代写,论文代写-ESSAYSHIFU 墨尔本代写,博士论文代写,网课代修,exam代考-熊猫代写 悉尼essay代写,CS代码代写,CS编程代写-熊猫人代写 澳洲CS assignment代写,c++/c代写,python代做-SimpleTense 悉尼代写,商科assignment代写,网课代修,论文加急-OnlyEssay 澳洲作业代写,essay代写,网课代修,exam代考-ESSAYSHIFU 代写essay,代写assignment|DRS英国论文代写留学推荐网站 Assignment代写,【essay代写】美国作业代写-留学代写ESSAY网